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.
N550CBCarnevale Philip A · Lake City, FLN550CDCoen Scott D · Kingsport, TNN550CERobinson James K · Eagle, IDN550CVGoodwin-Huber-Wilhelm Linda Lee · Santa Fe, NMN550DBHarding Mason · Phoenix, AZN550DDSaratoga Aviation LLC · Rocky Mount, NCN550DEJanay Jesse A · Charlottesville, VAN550DFArrow Aircraft Leasing LLC · Tucson, AZN550EEEidal Peter M · Kent, WAN550ERCoco Aircraft Inc · Merritt Island, FLN550FK38884 LLC · Moorhead, MNN550FLKennedy Adam B · Des Moines, WAN550FSRegistration Pending · Sheboygan Falls, WIRegistration pendingN550GRClark Robert E · Meridian, MSN550JAAlves Gerald T · Alamo, CAN550JBBowley John P · Middletown, NYN550JEEssert Joe · Windsor, CORegistration expired, pending cancellationN550JKTaffet Jay · New Orleans, LAN550JRUrban Cowboy Aviation LLC · Richland, NEN550JSBawk Aviation LLC · Xenia, OHN550KBPradelt Charles · Queen Creek, AZN550LAOscar Tango LLC · Mesa, AZN550LEFlycarolina LLC · Concord, NCN550LMAdventure Day Aviation LLC · Greensboro, NCN550LWWasserott Charles G · Owasso, OKN550MBRegistered aircraftN550MGGriggs Matthew J · Tunkhannock, PAN550MHAviation Education Services Inc · Tetonia, IDN550NCTri-State Communications Inc · South Sioux City, NEN550NDPhoenix East Aviation LLC · Daytona Beach, FLN550NVHoffman Andrew Todd · Mound House, NVN550PWhitmus Christopher A · Bowie, TXN550PEHeller Ross S · Gig Harbor, WAN550PJPeterson Todd · El Dorado, KSN550PUSkyborne Airline Academy Inc · Vero Beach, FLN550RNovember Sierra Aviation LLC · Oneill, NEN550RESimply Living LLC · Fort Myers, FLN550RGBr Ventures LLC · Port Orange, FLN550RJHovermale Ken · Portland, MEN550RWNine Six Livestock Co · Sterling City, TXN550SNortheast Cubs LLC · Wilmington, DEN550UClear Sky Aviation LLC · Mccall, IDN550WHAlligator Inc · Lawrence, KSN550WPJacobs Justin · San Francisco, CAN550X550x LLC · Tucson, AZN550YRFriedman Michael S · Chantilly, VAN550ZKAviation Trust Company LLC Trustee · Oklahoma City, OKN5510FHughes Arlen L · Saratoga, WYN5510MPatterson Philip Allen · Ailey, GAN5510QN407ml LLC · Wilmington, DE
Back to AD 2007-04-19 R1