AD 2007-04-19 R1
Registered aircraft · 108,434
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N4917NHanging On The Prop LLC · San Tan Valley, AZN4918CJetblack Ventures LLC · Bakersfield, CAN4918FBarnes Charles G · Louisville, KYN4918JWoolley Charles K · Clarksville, TNN4918LAthene Solutions LLC · Coral Springs, FLN4918QNauta Larry D · Soldotna, AKN4918SSilverado Sales Inc · Orem, UTN4918UMission Aviation Fellowship · Nampa, IDN4918YGrathwohl Air LLC · Bloomfield Hills, MIN49192Torii Aviation LLC · Naperville, ILN4919DDewitz Mark A · Good Thunder, MNN4919FTice Denzil · Farmville, VAN4919LCroft Jeffrey W · Tennessee Colony, TXN4919NKoffeman Edward · Midlothian, TXN491ACEw Pegasus LLC · Walnut Creek, CAN491AFMeyer Terry L · Wayne, NEN491BAirside Kc LLC · Riverside, MON491CCBarbee Johnny Lee · Fort Stockton, TXN491CMMottinger Casey P · Elizabeth, CON491DKey City Fliers · Maquoketa, IAN491EREmbry Riddle Aeronautical University · Daytona Beach, FLN491ETKennebeck Ronald C · Johnston, IAN491FLWashington Fliers Inc · Pantego, NCN491GShelton Christopher O · Aubrey, TXN491JPGuy Jeffrey · Centerburg, OHN491MABelle Casa Sport LLC · Tarpon Springs, FLN491NDChristiansen Aviation LLC · Wilmington, DEN491PDAir Ventures Awaits LLC · Middletown, DEN491SGryphon Ventures LLC · Apollo Beach, FLN491SAShier Aviation Corp DBA · San Diego, CAN491SFSnohomish Flying Service Inc · Snohomish, WAN491SGGott Shelby L · Tucson, AZN491SPLittle Rock Lsa Leasing And Rental LLC · Searcy, ARN491WMRenlim Aviation LLC · Brookhaven, GAN491WSDhs Operations LLC · Wilmington, DEN4920ABerry Thomas R · Anchorage, AKN4920GEye Candy Aviation LLC · Jacksonville, FLN4920LLvc Air LLC · Allen, TXN4920PDetert Bradley · Valparaiso, INN4920SExecutive Flyers Inc · Sacramento, CAN4921AHogan William J · Libby, MTN4921DMills Air Service Inc · Marstons Mills, MAN4921FCa Aviation 172 LLC · Santa Barbara, CAN4921JHerdrich Sean D · Manchester, IAN4921LBarrett Howard L · Austinville, VAN4921PAndre David E · San Jose, CAN4921RBas Part Sales LLC · Greeley, CON4921VFrumkin Mark Steven · Pittsburgh, PAN4922DD Gordon Aviation Inc · La Jolla, CAN4922GBishop Air LLC · Elk Grove, CA
Back to AD 2007-04-19 R1