Skip to content

AD 2007-04-19 R1

Registered aircraft · 108,433

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

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

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.

N201BBLet'S Go Aviation LLC · Sheridan, WYS/N 24-0099 N201BHSauder Richard J · Evergreen, COBuilt 1976 · S/N 24-0044 N201BJWheeler Robert J · Tyngsboro, MAFirst renewal noticeBuilt 1976 · S/N 24-0010 N201BKBma Flyers Inc · Caledonia, MNS/N 24-0056 N201BLBadiozamani Abdolhamid · San Diego, CABuilt 2005 · S/N L2K 177 N201BMGowharrizi Eddie A G · Los Angeles, CABuilt 1977 · S/N 24-0368 N201BNDodson Tiffery D · Chattanooga, TNBuilt 1978 · S/N 24-0425 N201BPBibilonisambolin Victor · Kyle, TXBuilt 1978 · S/N 24-0427 N201BTSteve Lunsford Corp · Saint Petersburg, FLBuilt 1978 · S/N 24-0433 N201BUSteidinger Mark W · Menomonie, WIBuilt 1977 · S/N 24-0320 N201BVBroussard Anthony Steven · Bismarck, NDBuilt 1978 · S/N 24-0434 N201BWHatton David Trustee · Columbus, OHBuilt 1978 · S/N 24-0431 N201BXTimari Mark M · New Monmouth, NJS/N 24-0435 N201BYHart John William · Durham, CABuilt 1978 · S/N 24-0436 N201BZ1bz LLC · Orange Park, FLBuilt 1978 · S/N 24-0437 N201CBMooney S Fifty LLC · Seattle, WABuilt 1978 · S/N 24-0576 N201CDHill Richard A Trustee · Campbell, CABuilt 1976 · S/N 24-0063 N201CGNew Orleans Aviation LLC · Slidell, LABuilt 1976 · S/N 24-0030 N201CKRegistered aircraftBuilt 1978 · S/N 24-0440 N201CLWings Aero Club LLC · Union Hall, VABuilt 1967 · S/N 18258712 N201CNCamp Teresa A Trustee · Newalla, OKBuilt 1978 · S/N 24-0441 N201CQMincuse Inc · Wilmington, DEBuilt 1976 · S/N 24-0068 N201CSMoore Michael R · West Plains, MOS/N 24-0123 N201CTFrye Lyndal D · Aurora, COBuilt 1976 · S/N 24-0046 N201CXAlfonso James · Overgaard, AZBuilt 1977 · S/N 24-0443 N201CYTriplett James B · Oxford, MABuilt 1978 · S/N 24-0444 N201CZWinborne Jonathan A · Rockville, MDBuilt 1978 · S/N 24-0445 N201DRegistered aircraftS/N TK-24 N201DAGoodrich Pilot Training Center LLC · Johnson City, NYBuilt 1977 · S/N 24-0094 N201DBMatthews Terry D · Arlington, TXBuilt 1976 · S/N 24-0026 N201DDRegistered aircraftBuilt 1977 · S/N 240102 N201DFFlying Fox LLC · Spotsylvania, VABuilt 1976 · S/N 24-0061 N201DHRegistered aircraftBuilt 1976 · S/N 24-0025 N201DJFoerster Jochen G · Inverness, FLBuilt 1976 · S/N 24-0050 N201DMN201dm Corp Trustee · Wilmington, DEBuilt 1976 · S/N 24-0060 N201DNSale Reported · Hudson, FLSale reported, pending cancellationBuilt 1977 · S/N 24-0163 N201DQBrande Lewis · Alta Loma, CABuilt 1977 · S/N 24-0091 N201DRKpjp LLC · Spicewood, TXBuilt 1976 · S/N 24-0028 N201DUSiniscalchi Joseph W · Heath, TXBuilt 1977 · S/N 24-0119 N201DVDevine Robert L · Condon, ORBuilt 1977 · S/N 24-0088 N201DXDe Young Miles J · Florence, COBuilt 1976 · S/N 240027 N201DYDrenner Scott · Mount Pleasant, WIBuilt 1965 · S/N 857 N201EBIsrael Raj · Saint Joseph, MIFirst renewal noticeBuilt 1977 · S/N 24-0112 N201ECHaselden William C · Hastings, MIBuilt 1978 · S/N 24-0635 N201EDRhodes Emmer F · Newton, IABuilt 1977 · S/N 24-0097 N201EENational University Services Inc · Salem, VABuilt 1976 · S/N 24-0076 N201EFDace Ronald K · New Berlin, ILBuilt 1977 · S/N 24-0130 N201EHLindsay Construction LLC · Fernandina Beach, FLS/N 24-0144 N201EJVann Dudley C · Greenville, NCBuilt 1977 · S/N 24-0159 N201ELAa-Aero LLC · Lewes, DEBuilt 2026 · S/N 172S13545

Back to AD 2007-04-19 R1