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.
N53777Bernabucci Christian J · Mapleton, NDN5377CAnderson Robert C · Zanesfield, OHN5377DDesantis Anthony · Memphis, TNN5377EHamilton Chris · Livermore, CAN5377PRegistration Pending · Litchfield Park, AZRegistration pendingN5377SHicks James S & Hicks Sally J Edgar Trustee · Oregon City, ORN5377VShoemake Stephen Sidney · Pine Mountain, GAN5377WJackson Timothy J · Hartselle, ALN53785Fox Business Advisors LLC · Mesa, AZN53787Jones Carl L Jr · Edmond, OKN5378DMustang Sally Aviation LLC · Camden, SCN5378ENuxoll Randy G · Eagle, IDN5378HFellman Peter A · North Chatham, MAN5378KUnique Educational Experiences Inc · Signal Hill, CAN5378LPeterson Dru J · Riverside, CAN5378PBlue Skies Today LLC · Eagan, MNN5378WHargis Bookman LLC · Justin, TXN5378YRagwing Flyers LLC · Richmond, TXN53791Maseman Paul A · Tucson, AZN53794Rick Aviation Inc · Newport News, VAN53797Christiansen Aviation LLC · Wilmington, DEN5379ABrechtelsbauer Paul · Farmville, NCN5379BBtp Inc · Missoula, MTN5379EMahoney Blair P · Columbia Station, OHN5379SStevens Michael J Trustee · Park City, UTN5379YHandly William A · Arcola, MSN537APa28 Aircraft LLC · Wilmington, DEN537ACMacmillan John Jr · Chevy Chase, MDN537CCKincaid James B · Hamilton, MTN537CDSullivan Scott W · Sandy, ORN537CLAckerman Terry L · Brookings, SDN537DStonebraker Properties LLC · Sierra Vista, AZN537DMKrakoff Matthew · Massapequa, NYN537EREmbry-Riddle Aeronautical University Inc · Prescott, AZN537FLHanson David Lawrence · Tucson, AZN537HPBarr Air Patrol LLC · Mesquite, TXN537JHBuffington Matthew Hill · Highlands Ranch, CON537JPPerkins John D · Salem, NHN537KSKent State University · Stow, OHN537MGizmo Aviation LLC · Roswell, NMN537MAK2 Aviation LLC · Greenwood Village, CON537MMMarshall Aviation Services Inc · Elkhart, INN537NDSpartan Education LLC · Tulsa, OKN537SAMills Michael R · Saratoga Springs, NYN537SWBingham Leasing Co Lc · Mesa, AZN537TCHernandez Carlos A · Litchfield Park, AZN537TTDudley Lee Brent · Passadumkeag, MEN537VBruno Airways LLC · Fayetteville, GAN537WMWeaver John D · Susanville, CAN53800Blue Earth Flying Service LLC · Blue Earth, MN
Back to AD 2007-04-19 R1