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.
N345CBR&E Bv LLC · Jupiter, FLN345CFLowery Ron L · Batesville, ARN345CGHargis James L · Tioga, TXN345CHAce Flight Center Inc · St Thomas, VIN345CPCat Aviation LLC · Doral, FLN345CRAlbion Aviation LLC · Florence, SCN345CSFlight Training Aircraft LLC · Wilmington, DEN345DWalker Benjamin Kelly · Myrtle Beach, SCN345DAGrigg Apiaries Inc · Hot Springs, MTN345DCDaus Jeffrey · Louisville, KYN345DESale Reported · Dover, DESale reportedN345DTPlane Fun Inc Tr Trustee · Snellville, GAN345DWAir Research Ca Inc · Torrance, CAN345EMLittle J Aviation LLC · Roswell, GAN345ETKeene Warren · Post Falls, IDN345FAAtp Aircraft 4 LLC · Wilmington, DEN345FDGolden Age Air Museum · Bethel, PAN345FHHeavy Metal Air LLC · Farmingdale, NYN345GWVertical Kinetics LLC · Superior, MTN345HHBeito Delray E · Strathcona, MNN345HPMarek Gary A · Lemont, ILN345HUSkydotcom LLC · Inver Grove Height, MNN345JBWarda Jacqueline D · Mckinney, TXN345JGGo Fly Inc · Spring Hill, FLN345JHHurst James H · Longview, TXN345JREastern Stearman Inc Trustee · Leesburg, VAN345KRBlue Sky Aviation Cayman Inc · Wilmington, DEN345KVHill Cannon E · Sun Lakes, AZN345KWHasch Edward L Jr · Franklin, TNN345LHSmoketown Helicopters LLC · Smoketown, PAN345MKNorth Star Aviation Inc · Mankato, MNN345MPPeterson Michael A · Smithville, MON345PCBeers Suzanne M · Colorado Springs, CON345PGN345pg LLC · Chicago, ILN345PMMay Benjamin V Jr · Charlottesville, VAN345PPHolman Ricardo E · Pleasant Hill, ORN345RADavis Scott · Morse, TXN345RBBarnett Russell L · Ozark, MON345RDMoyers Wallace Gene · Shallowater, TXN345RTSky West Aviation Inc Trustee · Albuquerque, NMN345SFFabiszak Stephen J · Roy, UTN345SLHawkins Larry L · Farmington, NMN345SPReese Andrew B · Chadds Ford, PAN345TBInternational Air Services Inc Trustee · Carson City, NVN345TCCaplette Gregory A · Mariposa, CAN345TFWilkinson Mark A · Lincoln, MAN345TJOpa Flys LLC · Magnolia, TXN345TKKieffaber Thomas M · Sagamore Hills, OHN345TMScott Daily Inc · Ash Flat, ARN345TSUncle Bob Consulting LLC · Antioch, IL
Back to AD 2007-04-19 R1